Camping at r/v campgrounds is really fun, but considering you've never been to a drive-inn I doubt you've camped in a RV either.

You have to have a good pickup to haul these, so unless you are planning on upgrading your vehicle, it is out of the question. They take up a sizeable parking space, so be ready to dedicate most of your driveway to it. In your case, it could become a real eyesore if it is right up against your house. Most people that have an r/v or larger 5th wheel camper have a dedicated garage for it, or at least have plenty of parking space out behind a garage or something.
The cool thing about r/v camping is that a space usually costs about $20/night and includes electricity and water hookups. In most places it also includes access to their facilities: lodge, game room,pool, etc. The atmosphere in a campground is very friendly. Your kids will have plenty of playmates, and you will find some people to hang out with too.