Not sure how long you can stay there, and it is a little outside KC but
Blue Springs Campground is really nice.
That's all I got: we've been to KC once to see a baseball game and stayed there.
Google Maps Link
RV Park Reviews Link
There are some forum members very familiar with the KC area...I'm sure they will be around.