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.
I always use this rule when I just can't think of the right shutter speed. At other times I guess.