The local Amish family has a rat terrier that takes care of their rodent and stray cats. It does not bother their livestock. But I would say this is the exception, not the rule. Terriers are a difficult breed, but can be fun too.
I have to agree with lockedhearts on this.