[Soothing Shrimp]

... It gets extremely noisy and messy.

I find the bubble noise soothing, but you can reduce the sound to almost nothing if you have the tube ABOVE the water line.

As long as the water from the tube still spills over into the water, you are good.