Cascade River State Park
One of many waterfalls at Cascade River State Park, just north of Lutsen, MN, along the North Shore of Lake Superior. I braced my camera on a fence post to nab this 1/2-sec exposure.
To get that kind of "sharp-yet-soft-and-dreamy" look in Photoshop, after sharpening duplicate the base layer. (Yes, usually you sharpen as a last step, but not in this case.) Apply a large amount of Gaussian blur (filters--blur--Gaussian blur). Then reduce the opacity of that layer to between 20 and 40 percent (your mileage may vary). Flatten the layers and you're done. Fun with Photoshop!