We have 2 Corgis. They are hilarious. Very full of energy and love. Our male is a little afraid of hrights, but hey it's kept him off the couch all these years, so that's a good thing.
When they were puppies we had to train them not to herd the children. they would run after them while they were playing nipping their heels and trying to get them in a certain area of the yard. They were very gental about it but still not a behavior we wanted and they were very easily trained.
They LOVE their chickens. They like to hang out with them. They watch over them and are very protective. We actually had to rehome a dog when we got chickens because he killed a few and the corgis were MAD about it. They would protect the flock form our other dog and it led to fights.
Our female is actaully motherly to the young chicks. Every new peep we hatch out must be sniffed from head to toe when it comes out of the bator. It is the funniest thing ever. She just loves them.
They are fantastic with the kids. If you want a dog that will play fetch this is your breed. they also run with our oldest son and keep up well. At the same time they love to snuggle and make a great lap dog. They do bark a lot at times. Our boy is also very good friends with out little pygmy goat (we have one little regualr sized goat and one very oversized pygmy goat). He also likes to herd the ducks around the backyard. I think with some work it could be really helpful. But right now he just does it for the joy of it from time to time. He NEVER touches the ducks except to sniff them.
I would get another one ina a heart beat. they are fantastic. And they always look like they are smiling. Who could resist that?
No experiance with Great Danes. It's one of my dream dogs, but DH says no. He never says no, so I have to listen on this one.