Hey there potential dog owner,
Your post has taken me back a few years to the pleasant memories of having a dog - and some happy tears.
For many years, I was the proud owner of a PALS dog. The Pet Access League Society is a not-for-profit organization that is dedicated to providing people with pet therapy. My Dexter (Sir Bark-A-Lot), an American Eskimo dog, retired many years ago and lived out his mature years on my parents' ranch. Even when the country was free and open to him, he would still go and fetch his leash and bring it to my parents so he could go outside. They would open the door and say, "No leash here Dex." It took a while, but I taught him how to whisper (tiny woof) rather than to BARK because this type of dog can come with a protective, piercing bark. That is another thing to consider when considering a dog.
On my way to work, I would drop him off at an on-the-way hospital where he would take the elevator up to the children's ward – with the help of the reception desk person. At the end of the day, he would be waiting for me on an outside step. On occasion, his hair would be different colors and in little braids or even a bit shorter, depending on the creative energy of the children patients.
If dogs, no matter the size, are trained with consistency, they will never take over the lead and will listen unconditionally. My daughter has two dogs that go to the office with her every day. Pepper, an Alaskan Malamute, is the "greeting control officer" and Braddock, a mix but mostly German Shepherd, is the "crumb control officer." Their photos are on the personnel website page.
A well-trained dog has a well-trained owner. For example, Abby, a black Labrador, who belongs to a friend of mine in a retirement community in Boulder, Colorado, has trained his dog like I have never seen before. Abby was trained not to cross the curb, on any street, until given a specific command. The nearby squirrel community has figured that out, and now they walk side-by-side, with the curb separating them. Incredible!
Dogs are great company, so follow your dream, K.