I had service animals (dogs) stay at my place about 5 times. no problem whatsoever. i worried about all the issues you mentioned. we did not take pets. but they were impeccably groomed, silent and did no mess of any kind in the house. as has been said, they are amazing and, if they are true service animals, you will have no problem.
four of them i knew about in advance. the 5th was a complete surprise and the guests were hostile at checkin, waving a paper in front of me that they had a service dog and i had to take them. it would have been courteous and proper to tell me ahead of time.
but anyway ... i wondered if it was a true service animal until i watched it interact with the owner. it was a man who wore it on his person in like a baby carrier all the time. the man wore white knee high socks and sandal slippers and had serious issues communicating with people. one morning he all but broke the door down trying to get out of the room, pulled off the doorknob from inside and could not put the doorknob back on.
i was going to go in through a window (ground floor room thankfully) to open the door from inside. i stood at one of the windows trying to calm him down, telling him i would remove the huge screen so he could just step out. his wife was already over the edge dealing with whatever was going on in his mind.
in any case, he pounded and yelled and yanked on the door. shouted and stamped his feet. ran to the window and tried to keep me out! she sat in a chair and rocked. i was at the window trying to calm him down. my son was on the other side of the room door, taking off the hardware to open the door, using tools and making a lot of racket.
the little dog in his/her carrier was completely silent and unphased by the whole thing..
I'm sorry, gonna sway from the service dog topic here.
This was just way too much to have to deal with. That person has no business traveling about and the person with him/her is the person that should be responsible to handle the situation instead they blocked it out. And what about the service dog, brought I presume to calm him/her down? It was in it's carrier, not doing its job - not it's fault but that is the problem.
I do not mind and would not have a problem with a service dog serving a blind person and other physically challenging needs; but when it is emotional need it may be even too great of a problem for a pet... as your example shows. And where is the line to be drawn, how far are we as business owners supose bend when it affects other guests that paid for a quiet, peaceful stay?
.