I'd disagree on the herding breeds if you are talking typical breeds like GSD, Belgians, Aussies, Border Collies, etc. Almost every dog I've seen from these breeds typically has high prey drive. There are always exceptions of course.
The only other large breed I have 1st had experience with is Great Danes, and Daisy has moderate prey drive. She's still a pup at 9 months, but she will harass the cat, stalk and kill birds, and stalk and chase our pug. I've also seen on rescue sites that a lot of Danes are not good with smaller animals. Daisy also has a pretty fair ball/toy drive which is prey based.
If you want a big dog that won't kill your small animals, your best bet is strict training and uber-vigilance when they are together. I can let our parrot out with Gunnar because he's disciplined enough to be put in a down and not move. Daisy can't be trusted with the bird out though, not yet.