You might have a semi clogged heater core. That is under the dash and could be the cause of the noise. It might even be the servos opening up the vent doors when the car is started. Or maybe you do have a real waterfall under your dash. Sell tickets and let honey mooners stay there...........just kidding....
.
Russ