do your research and then go to the animal shelter and see what you fall in love with there that fits within your requirements. the people at the shelter should be able to tell you about the dog's habits and character. as far as peeing on stuff and barking loudly - that's your job to train him/her. a dog that isn't trained and given rules will soon do whatever it wants to do.
even if you are set on a certain kind of dog, there any many breed-specific rescue groups, and you should check those out first. those people know their dogs extremely well, and make it their job to fit their dogs with exactly the right person and home.