There is an old rule that indicates the best shutter speed for moving water is determined by the reciprocal of the fraction of the picture that consists of water. If water is 1/100 of the picture use 100seconds. If water is 1/2 of the picture then use two seconds.
Interesting rule of thumb. I'll will have to look through some old photos and see how this rule plays out!