spectrogram of a leak in a water pipe
I don't know, but my guess on this is: just like air flowing through a flute, water flowing through a tube causes vibrations, tones. The strong tone with several overtones is pretty consistent with this being similar to an air instrument.