If I was going to do what you want to do I would get a trailer able cat type pontoon boat like this https://www.catamarancruiser.com/8x31-lil-hobo-trailerable. It would offer the best of both worlds. You could tow it with a truck to a CG and use it like a trailer and when there is a lake you slide it off the trailer into the water and find a quite cove to sleep and fish in. When I camped at Lake of the woods in Canada they also rented these types of boats at the CG and people would sleep in them over night as well as fish.