Longer exposures will do more for getting ultra smooth looking surface water. However, if you are photographing when the sea or coast is not so turbulent, then about 30 seconds might be good enough. If you have visible waves coming in, or crashing on rocks, then you need longer exposures to average that out, though you might end up with some ghosted images of waves in the final photos.