Questions re bassets

I’m considering a basset Hound (vs a barbet) for my family. What’s the physical ability of a basset Hound like? I know they are curious and follow their nose and like to explore etc. however, we’re a fairly active family:

do they like normal dog things like playing catch and hanging out in dog parks? how are they with water? We live by a lake, will a basset enjoy jumping in and frolicking and swimming? how are they with really long walks (5km/3 miles or more) and hikes with woodland trails and moderate hills? I understand they can’t jump and leap but can a healthy adult basset Hound crawl up onto a bed or couch?

Thank you in advance to anyone who answers 🐾