That is really something to just experiment with. Depending on the lighting, you may want to try something around 1/8 sec to start with and then start stretching it out from there.
At around 1/8 second, you should get the sort of streaking looking water but still fairly clear. Start going over a 1 second exposure and you start to really get the "cotton" look to the water and the major soft effect. I'm doing this out of memory, haven't shot these types of photos in a while now...
Grab a roll of film and a notebook and then shoot a roll with the same subject and try a ton of different exposures (maybe 1/8th all the way up to several seconds) and record the exposure on each one. Then, after you get them developed, you can decide what exposures give you the effect you are hoping for (and don't forget to post some samples on here!).
Good luck,
Chase