There are a number of myths about working dogs, and these include the idea that you can't have a worker that is also a pet, a long with the idea that having a dog live inside will make it soft, and that a working dog will always be more aggressive than a non worker.
They are just that . . . . . total myths.
I have a total of six working dogs, including two terriers, a hound, a lurcher, a whipper and a spaniel, they are all worked hard, and some of then by dint of their working occupation are hard dogs, in the field, they are killers.
However, around people, children, other dogs and all livestock, they are soft as a brush, lovely natured and three of them (the whippet and the two terriers), sleep in the house.
With any dogs, its about how you bring them up, socialise them, and train them, and most problems can be traced back to the owner, rather than the dog. In fact, I have to say, I have met more dog, people and livestock aggressive pet dogs, than workers.
One final word of advise though, you need to train and socialise your children, almost as much as the dog! Many child vs dog incidents are ultimately the child's fault.