Steve
I too tried to find solutions for a boat of some sort. My reasons were for fishing getting on the water. I tow a toad some of the time so a trailer was out ,
I went to a boat show asking the Kayak mfg, with no good answers without putting them an the rubber roof ,I didn't like that idea. besides kayak are hard to fish from.
so I bought a FOLDING BOAT it attaches to the side of the RV folded up.They come 10,12,14 feet long and open to 5 ft wide check out their web site
www.porta-bote.com
Ive had it for 2 years now I'm happy with it. Its very stable for me standing in it fishing.
Good luck