If you are set on a dog being part of your recovery the likleyhood of some random people on the Internet being able to persuade you differently is unlikely, it may help and it may not but you need to consider the impact on a dog if you can't keep up the level of care they need.
Puppy's are cute and people like spending time with them but a middle aged dog that is suddenly not getting enough walks is unfair on the dog.
I do think however that you need to prove to yourself that you are capable of this level of exercise before getting a dog walking in the cold, rain, snow if you get it and in the summer when you need to walk early or late to avoid the heat on the hot days.
Make sure you have the spare time in your day to train and clean up messes.
Iv just today had to cancel the insurance on my 2 as its gotten too expensive and have gotten a credit card out as a just incase untill I can put some of the money I was spending into savings to cover emergencies.
Smaller dogs are yappy, and you mention a beagle, they don't yap but they do make alot of noise.
A close family member has one and while it's very cute it needs a lot if excersice, it likes to take itself for walks eg escape, on walks it's nose is engaged but it's ears are out of action so you can forget it coming back when you call if it picks up a trail.
It's also been very destructive in the house on days it hasn't had enough stimulation.
It is a lovely dog but has caused no end of problems.
Tibetian terriers are nice but are known to bark and need a moderate amount of excersice, the only one I know is very vocal.
If I had to suggest a breed I would say stick to the lap dogs, something that likes company and requires less excersise than other types of dog.
I'm not a lap dog person but the Biewer Terrier or the Maltese would be my choice if I couldn't manage the hearding breeds I favor.