A question for you all. Lend me your thoughts.

How does one make effective looking gushing water? Such as from...

• a fire hydrant
• hose
• high pressure pipe.. hehe
• dam over-flow
• geyser, etc.

I'm debating fibre optics, but am interested in investigating other routes.