Water always psyched me out a bit. The only really nice golf course I played on was in New Mexico, near Red River. I didn't enjoy it much and couldn't play very well because I'd just broken up with my girlfriend. Ah well, that was a long time ago.
This weekend my wife and I visited family in Brevard. While there we made a trip to visit the High Hampton Inn in Cashiers because its founder was a distant relative of my wife's.
The inn is set in the middle of the mountains and is really quite pretty. I got the impression that it's pretty expensive but we didn't stay so I don't know just how expensive.
This is a picture taken from a point near the main building of the inn. The peninsula in the middle of the picture has one of the greens. You can just barely see the flag on the green if you use your imagination. I believe that this particular hole is a 'dog leg' and the recommended approach is to hit the ball over the water onto the green in the middle of that peninsula.
I'm not a golfer, but if all the courses were surrounded by such magnificent scenery I could see the appeal.
High Hampton Inn