I have a BC and a GSD… neither would be my suggestion for a first-time dog owner. Really, you can have problems with any breed, but I’d maybe try to at least avoid the ones that naturally want to herd things. We have chickens, goats, cats, horses, and children and both my dogs are good around them, but I put in a ton of work from the time they were 10 weeks old to make that happen.
I agree with the suggestion of looking at rescues for a young adult dog…you might even find some that have foster homes with livestock and the other animals so you can see how they do around other animals first!