I would suggest considering an inflatable canoe. They are great for beginners, easy to store and super easy to transport. Also they tend to be quite affordable. I have been using one for years and absolutely love it. Here is some info and reviews on inflatable canoes if you are interested.