I grew up in a canoe in northern Minnesota. We even rigged our canoe to sail. I had many enjoyable overnight canoe trips with family in the boundary waters area of northern Minnesota and Ontario but it has been years since I"ve done an overnighter. I currently carry an inflatable kayak in the motorhome for tooling around streams and small lakes.
My uncle lived in Minneapolis, which has lots of biking and canoeing options. He used to throw his bike into his canoe, ride through a number of lakes and rivers, leave the canoe when he was done and bike back to his car. It always sounded like fun but I've never done it.