If I were a northern guy, and had the means and time to make it worth my while, ideally I would want to be a member at Jupiter Hills. Those Carolina courses are real good, but it gets cold up there. You can't plan a week of golf in January in the Carolinas.
Good weather is almost guaranteed in Jupiter. It's a beautiful place. The amenities are aplenty-good restaraunts, plenty for your wife to do, and probably two dozen flights per day to Palm Beach airport.
You'll have to wait a few years to get in, but you can play somewhere else until you do. I'd try to get on the wait list ASAP.