I get mine from the same location each time. Its in a bay and outside a harbour wall. (the harbour is a small fishing harbour and is tidal).
I can go past the harbour and there is a small dis-used jetty that is nearly always in deep water (spring low tides it can be shallow and difficult to retrieve water).
I always make sure that i get the water on the rising tide to make sure that its fresh sea water coming into the bay rather than water that has been there for some time.
As i have mentioned in other posts before, you should really test the water for each location as just a mile or so down the road can be a different st of results totally!
I made this mistake early on in keeping my tanks. My usual location was not accessible (the closed off that part of the village for a carnival) so i decided to go to a nearby location (about 8 miles away) and get water from there. I did this without testing the water and putit in my tank. Disaster struck
Within hours (literally) i had cyano covering all over the sand and rocks. It took weeks to get rid of this problem. After i nvestigation i discovered that a huge oil tanker had crashed on rocks there many years before and the oil had now sank under the sand in this area so it was very rich in nutrients
However, the area i get mine from is very clean and has been awarded with the European blue flag for cleanliness.
If you do wish to try out NSW then i strongly advise you test the ater first. then just do periodic water changes to see how things go. If the tank seems fine then increase these changes until you are happy.
Hope this helps.