Long exposure is a good way to reveal water movement.

2 to 6 seconds depending on water flow speed is a good average and, of course, you will need a tripod !

If you want to make sure you have all key success elements on your side, then think about using a remote shutter release system. This will prevent any camera movement during your shots…

This is only for the technical piece of course, the creative one is still on your side !