We have been snowbirds in Florida (from Michigan) for the last three years. Duration of our stays have expanded each year. We have stayed at a combination of state, municipal and national parks as well as private facilities. It sounds like you may want to try a variety of places, shopping for you personal favorites. Here is what our experience has shown:
Myakka River RV Resort is a very nice, full service facility. Decent sized lots. Near Port Charlotte. Pool, lots of planned activities if you are so inclined, nice staff, on the river, allows pets, moderately priced for what you get. Just spent the month of January there.
Naples Motorcoach Resort and Marina (the marina part is almost a joke...) Very nice. Multiple pools, social events. (I found the staff almost snooty...)Expensive.
Fort Wilderness at Mickey Mouse's home also received good reviews.
State parks with full service sites (Elec, water and sewer) can be found at Johnathon Dickenson as well as a few other parks. There is no organized social activity, no pool, etc. But it is a lot cheaper.
Fort Desoto is a county park located in Tampa bay. The sites have only water and electric, so you need to trek to he dump station if you stay longer than the capacity of your tanks. Near all that Tampa, St. Petes Beach, and surrounding area has to offer.
I suggest that you start with a place like Myakka River to get the wife in a positive frame of mind about snowbirding... Then you can introduce other venues as time passes. Expand your horizons!