I'm actually surprised! You have kids and a husband that often travels for work. I figured you had at least one companion animal to keep you company.
When the kids were young and DH was away more than he was home, I got myself and the kids a large guardian breed dog. Great company when I was alone at night after the kids went to bed, cuddles anytime I wanted them, and a good guard dog in case of emergency.
I currently have an American Bulldog (he's the guardian breed if you aren't familiar), a Pit Bull, and a Basset Hound. I also have a 35 year old tortoise, a 5 year old African Grey parrot, and two 2 year old Betta fish that my daughter left when she moved out.
On New Years Eve, our 15 year old cat passed away. DS, who is also 15 and grew up with the cat, is brokenhearted. I asked DH if we should consider getting a new kitten from the local shelter, but he said he would prefer not to. Something about not needing to have the entire food chain under one roof....
Before we bought our house, we had an 800 sq ft 2 bedroom single story rental with us, 3 young kids, a dog, and two cats. The cats were lazy and were pretty much window sill decoration. The dog spent most of his time sleeping and got his play and exercise needs met during his walks. It worked out well, but I must say I was happy when we bought a larger house. Not because the dog was underfoot, but because the kids were!
If OP has trained his pet and does the feeding, walking, and cleaning related to the dog, even the small space shouldn't be much of an issue. If the dog was a marauding beast in need of training and discipline, it would be different.