Ultrasound modules meant for use in air indeed don't work for water. It's to do with the impedance difference. Water is a very different medium than air (much higher density) so needs a different transducer.
It's an interesting problem - not many suitable transducers out there. This one came up on this forum a few years ago and may do the job. Fish finders are another option indeed.