You want the smallest that you can sleep 4 people in, for a
couple of nights?
AND still have 4 happy people afterwards? That is if no one was thrown overboard.
If you want to "weekend" a few times a year, rent a houseboat.
Or a cabin on a lake, best of both worlds.
One person, or maybe two...