There are so many approaches. What I have found useful is to carefully watch the motion and determine the speed at which the water is moving. Using that as a gauge you may be able to get a good sense of what the effect will be at different speeds. Here are a couple of things to keep in mind:
- Smooth flow results in smooth lines when blurred
- Water falls are usually accompanied by spray that will scatter additional light on a long exposure
- Fully frozen motion often looks like no motion
- In turbulent water there is almost always one or more portions that are completely or almost stationary. The trick is to find a shutter speed that will blur some portions and stop others.
- Rapidly flowing water may yield interesting textures at moderately slow speeds
I like to leverage the last two points. Below is an example of partial stop of turbulence at 1/13s.
Here is an example of texture. This is a film shot and I have no record of the shutter speed, though I believe it was probably about 1/10s.
And this one is just simply limited blur. The curl was intermittent, and the exposure was timed to trace the surge for only about 4-6" of travel (1/26s).
The cool thing is that with a digital sensor you are free to experiment and hone your craft. Have fun
Steve