Parents house has a pretty big garden, and they want me to do them a bit of a waterfall type thing.

I'm good with electrics, so can sort all that, but don't know much else. Do you need a permanant water feed? I can pipe one down if needed. Defo don't want a pond - im thinking a combined water fall and fountain type thing....