I lived in NC a couple years (Near Morganton), and mobile homes were everywhere. But I'm not surprised you cannot do this for an RV.
This very same topic has come up occasionally over the years on RV.net.
One way to get around the zoning problem is to have a small building built on the property, which is a permanent structure with compliant electric and sewer services attached to that building. That actually might be a good thing. It would give you additional storage space, somewhere to store a lawn mower, and maybe even a roof for your car.
Then run an additional "clean out" for the sewer which can double as a dump station for the RV, run a separate 30 or 50 amp line for electric service for your camper. Now you are properly zoned, you have a permanent structure, it's not disputable, and you can park your camper there and live in it as much or as little as you want. Just make sure the building meets all the requirements to be a structure that is considered "livable" ... bedroom, bathroom, kitchen. And you can park the camper there all you want.
That's how you get around it.