If you really want to stay at the campground, I would go over to the camping board and ask if any of the people who rent RV's allow pets. A rented RV would be able to utilize a site in a pet friendly loop - so it would just be a matter of finding someone who would allow you to have a pet in the rented RV.
The camping board is full of info you won't find here on the resorts board because it's so camping specific.