As Richard has said, it's all about the shutter speed.. the filters are only a tool to get you to the shutter speed you want.
From about 1/3-1/4 second and longer you'll get the water blurred. How long you go on the shutter speed depends entirely on the effect you want. Too long a shutter speed and the water might become too whispy, or that could be the effect you want.
About the only essential is a tripod when you get to these shutter speeds.
If you were shooting in broad daylight, open sky conditions and your camera was giving a suggested exposure of:
ISO100
f/16
1/100th
(sunny 16)
Then 5 stops would get you to about 1/3rd second, you could achieve this by closing the aperture to f/22 and a 4-stop filter. Or opening the aperture to f/11 and using a 6-stop (or a 4-stop plus a 2-stop).
Once you start moving away from daylight and open sky conditions, e.g. early morning, late evening, winter, under a full or partial tree canopy, you're already going to be closer to the desired shutter speed due to the reduced light levels and you may get away with a less powerful filter or no filter at all.
Have a search for "welding glass" for the cheapest high-stop filter of them all.. 12-14 stops of almost-ND filter for £5-7.