I can attest to the hearing abilities of the miniature Dachsund.
A neighbor has a lab. When I commuted on foot, he always let the neighborhood know I was coming when I was in a foul mood. After a while, he lay silent on the days I was cheery. I can only imagine he was picking up on my pheromones or something...
I have a Rottweiler-Dogo mix, good dog. Very sociable, sweet, and utterly non-aggressive. Great family dog, but he loves playing with our cats and other dogs when he can. VERY athletic and strong! He's about 100 pounds at 11 months and he lets us know when something's up. His bark is frightening. I once got locked out of the house and tried to shimmy my way in through the back and he lit the place up with a massive, powerful bark that scared the **** out of me. He's basically a Molosser breed so like any good Molosser he will first knock you down by tackling, and by God he can do it! Good luck to anyone who gets into it with him...
Your best bet is to get a smallish dog to sound the alarm and a big dog to back him up. They'll keep each other company as well. I had a greyhound when I was growing up and he was the perfect dog, obviously incredibly athletic and fast, he loved to play but he was basically a 90 pound lap dog. They require no maintenance (they are happy to sleep all day or cuddle) but he stopped two attempted burglaries quick, and one time the cops were at the house he went ballistic. He terrified my friends due to his size and musculature, but he only went off when necessary.
For a big dog, the Scottish Deerhound is a great choice. They're huge dogs, but they're as athletic as anything out there and are nearly as fast as greyhounds which they are closely related to. Unlike greyhounds they're great fighting dogs, and are also in love with game coursing. The Australians found they were the only breed that could both chase down a wild ozzie boar and kill it. Other breeds could do one but not the other. Great breed.
Good luck.