It should be REAL WATER flowing, why emulate it ?!... MAKE something cheap that water actually flows down with the logo / title in backdrop... Have a raft busting through the flowing water in the backdrop etc...
like these things that are $57 bucks...
http://www.houzz.com/promo/20363915?m_refid=PLA_HZ_20363915&device=c&nw=g&gclid=CNHyz6mvtsgCFcQUHwodwoAG-w
mrclean_whitewater_idea.jpg