I'd personally like a slightly larger dog but even though our yard is fully fenced, much of it is chain wire and only a metre or so high, so unless I want to replace/modify the fences, we need to select a breed that doesn't climb or jump.
Again that comes down to training - we've got a Collie x Kelpie that somehow we've managed to train not to:
1) Go under or through the front fence (<3' high post and 2x rails) - it does have a hot wire low down, which she has hit a few times, but even if her (beloved) soccer ball goes under it, she won't follow it, instead sits there looking at it for as long as it takes you to get it for her. We can even leave the gate open on the driveway and she won't go out. In fact, the hot wire and closed gate are more to keep the neighbour's dogs out...
2) Go over the side fences (3' ish ring fence)
3) Bark at anything that is "normal" - however, fox, some dogs and a couple of other things are fair game and encouraged
Bearing in mind her sister is able to clear a 6' fence, and frequently does, it's a mix of luck and consistent training. The not jumping of ours is funny, as she expects to be lifted over the fence to chase rabbits and magpies!
As ours is predominantly a house yard dog, she was in a kennel as a pup that was in range of the squeezy water bottle if she barked or whined out of turn. That's kept her quiet for the majority of the time, but if something is out of turn, then it's all go! The fox is the main one, but there's a few dogs around that she doesn't tolerate - to the extent she was going off when one of them was raiding the dog's food in the house opposite... their dog was doing nothing... Her kennel yard has a good view around out the yard, so she has some things to look at when we're out - I suspect she's a sleeping dog when we're out; she'd dug herself morning and afternoon holes depending on where the sun hits.
She also stays close at camp, sleeping under the car (I have had to reinforce the wiring though....) and just chilling most of the time.
Currently she is sharing her yard with 2x poddy lambs and is quite happy pottering around with them following her (although if the back door is open, she'll come in for some peace and quiet)
I think really it comes down to consistency - even though the dog will work of both of us, when she's out on a walk or a ride, we'll keep it consistent as to who is in charge (whoever has the whistle) so that she know's who to listen to. We do know she is a very tonal dog, if you vary your tone, she responds better - emphasis on some commands so she knows they're NOW commands ("here" = alongside, stay close: "come" = come to me), rather than in a minute ("this way" = follow me, or get a bit closer, not over there; used a lot when we're riding)
