The area around Shallotte NC has several year round CGs. You could call and ask about any problems they may have. I would think the problem would come in you hose, and not the water hookup. You may have to wrap the water hose with heat tape to keep it from freezing. Other than that. You should be good.
BTW. The beaches close to Shallotte include Oak Island, Long Beach, Yaupon Beach, Caswell, Holden, Sunset Beach, with Southport not far away with a ferry to Pleasure Island ,and Carolina, and Kure Beaches. Wilmington is also near by. And it is around an hour to Myrtle Beach.