[Mazin]

For rivers, streams, creeks, etc. you can make a plane, give it a noise displacement map, and animate the offset of the map to make it "flow."

For faucets, pouring water, etc. you can try Blobmesh, but it's tricky.