The South Carolina golf community is steeped in conservationism and offers a resort-like waterfront lifestyle with lots of reasons to get outdoors