what is the difference between an average rate of water flow and an instantaneous rate of water flow?

average is measured over some finite time interval.

Instantaneous is not. It is the limit of the average rate, as the measured interval decreases to zero.