I have a beagle. He is my beloved little hound and will snuggle with me for hours. That said, I take him running 3-5 days a week and he hunts with my husband on the weekends. That is the only way to keep his little hound brain sane. If he has 4 days off, he starts running laps around the house and pouncing on bugs.
It took a solid month to house train him, his recall when loose in the mountains is only so-so, he’s -never- loose in the city, and when he’s hunting, he’s not my little beagle snuggle anymore. Puppyhood took forever; he’s three and finally maturing out of it. He’s not overly destructive, but he’s extremely smart. He only applies himself to stuff he cares about though. He’s fast and athletic.
And oh yes, the smell. Hounds have ‘anal scent glands’. Guess where they are? Yeah. My beagle has been able to ease them himself, but if they get clogged, you or the vet gets to have a fun time. It also contributes to a distinct hound odor that you may notice if things get backed up.
He never was very noisy at home, which was great, because his noises are very distinctive. When we got a corgi, though, he learned to bay at people walking by.
I love him, but you have to understand hounds and be committed to living with them. The corgi is -vastly- easier to deal with.