Has anyone tried to put an HC-SR04 in a tube.

Further to the idea of using a pressure sensor I just came across this article which you might find interesting.
Read through the comments.

http://kayno.net/2010/02/11/wireless-picaxe-based-water-tank-level-sensor/

Paul