I love dogs and I can't imagine not having one. If I were you, I would agree to get a dog for the family. However, I would wait until your children are a little older. We lost my beloved Standard Poodle when my youngest was two. I was overcome with grief so we bought a puppy. It was so hard dealing with a toddler and a puppy. If you must get a dog now to make everyone happy, I would insist on a dog not a puppy.
Also, I agree with the posters who mentioned not getting a Border Collie for your first dog. My brother and his wife breed them. They are great dogs, but they are too smart for their own good and super high energy. Before you agree to any dog, thoroughly research the breed to find one that will fit with your lifestyle.
Suzanne