The only time I’ve seen it be appropriate was one lady at my work who trained service animals, and so the dog went everywhere she went. Every 2 years there would be a new dog in the building.
I am fine with service animals and well behaved animals. At my company they had a trial run with “work buddies”. It resulted in people bringing in their untrained mutts that would fight among each other, shitting on the floor and generally making a mess of the office. One dog tried to jump on me during a meeting and I shoved it aside, the owner came over and was all pissy that I wasn’t more friendly to his dog. That policy did not last long