You need to get yourself to a camping and caravan show Jim to check out all the options or at least a big dealership where you can view the various types. We've had a motorhome for just on a year now and there is a learning curve involved! We have a 8mtr coach-built low profile on a Ducato chassis with fixed bed in the rear and separate toilet and shower. This gives you less living space but we didn't want to be faffing about turning a lounge area into a bed every night. Plus it allows one to go to bed later or get up earlier independent of what the other is doing. Everything is a payoff though and with the fixed bed you need the extra length which results in the large overhang at the rear. This limits your options for parking as you need to be clear of everything alongside before making a turn. You can get a smaller maybe 6 mtr coach-built though.
Then there is the question of layout, wheres the bed? What type of bed - you can get singles, bunks, island beds, rear beds! Where do you want the bathroom and kitchen?
If you are renting it out I would think a panel van maybe a better option. These are smaller but more robust and easier to drive. Most people I've seen have a separate "drive away" awning which stays in position when they drive off to the
pub shops. Theses vans can be quite expensive, often costing more than a coach-built but they are really well fitted out. I'm a fair bit behind at recording our adventures but here's a link to my blog if you find yourself with time to read it.
Motor Home Tales And here's a link to the various types of MH out there.
Types of motor homes and if you're feeling adventurous you could build your own!
DIY camper conversion good luck with the venture Jim