These are the folks we used years ago when I was in the entertainment business. They are a small independent RV dealer and rent RVs owned by private owners. Near as I can tell they don't hav a website, but 10+ years ago they had much better deals than the larger national RV rental places:

SAL Enterprises
5000 Akron Cleveland Rd
Hudson, OH 44236
(330) 656-4014

RVs aren't cheap, a nice one is probably going to be $1000-2000/week plus mileage.

I don't think there's anything wrong with the idea; we've talked about it before, we just didn't have the time to take 4 or 6 weeks off to shoot content, and since we do mostly large shoots now, driving from place to place didn't make as much sense. But AJ just inherited a rather large RV from his grandfather, and so we've talked about the possibility of using it this summer for just such an endeavor.