How can I make water follow a path?
Have a look at the blender manual here.

You can also simply use SPH particles and move the emitter :



the particle settings can be improved to look more like a fluid but that's the basics.

Here's the Blend file :