Using a piston is interesting. I'm not that advanced in my gameplay yet but I'll have to come up with some ideas. It's difficult to find a source of water that's high enough up.

Can you use buckets to create an artificial lake? I may have to try that.

Flowing water would be amazing though.