Dachshund. Supremely loyal to you and yours, ever-vigilant about the house, AND packs a whole lot of loud barking in that long little package.
Dachshunds are great dogs, and also of the hound group.