My wife and I decided couple years ago to get a "house dog". I've always had "outside dogs" living on the farm. Her parents had "inside dogs", chihuahuas and poodles. We knew the responsibility of keeping a pet indoors but decided to finally bite the bullet and get a dachshund. We knew exactly what we were getting. They are very aggressive, protective, and loving to a fault.
Last year we went to the beach and left "Merle" in the bathroom. He tore a hole in the door that was already in bad shape. Settled for paying 1/2 the door cost with the manager. Took "Merle" to see my mother-in-law last July 4th. Little scutter did the same thing. Another bathroom door. In addition when we took a pee break at a rest area he nipped a well wisher wanting to pet him even after my wife told him "Don't do that". He was on a leash.
The only time we take "Merle" out is to the groomer, to the vet, or over to my mom's house. He stays in the home and gets walked daily. He's a handful but we love him.
I have no problem with dogs in public places as long as the owner is responsible.