I was once involved in a project using HC-SR04's to detect humans.
Detecting a nice, big flat surface like water is an almost perfect case for an ultrasonic sensor

As a side note: the vast majority of HC-SR04's out there use a badly configured 40KHz filter, if you change few resistors then their performance gets dramatically better.
I can't remember if there is a max dist hard-coded in, I don't think so (you already have to reject early return echos for X time after sending an output pulse). They're cheap, so I'd say try it and find out.
There are more expensive ultrasonic transducers available from a variety of vendors if the HC-SR04 ends up being distance limited.
Any "datasheets" you come across for this part are meaningless. They all make different numbers up. These parts are made by a few different people (you will find different layouts for the PCB) and quality even within one batch varies notably.