Yes — the silky water look is created with a longer shutter speed so the moving water blurs while the rest of the scene stays sharp.

A tripod or other solid support is important to keep the camera still. Then experiment with shutter speed depending on the look you want and how fast the water is moving. Faster or heavier water may need less time; smaller streams may need longer. Exposures can range from well under a second to several seconds or more.

Don’t assume the longest exposure is best. Too short may not smooth the water enough, but too long can make it look overly flat or icy. Try a few different times and compare.

To avoid overexposure in daylight, use a smaller aperture, lower ISO, or an ND filter. A variable ND filter can be especially useful because it lets you fine-tune how much you lengthen the exposure.

In short: steady camera, slow shutter, and some trial and error.