Not sure if you have owned a hunting breed or not.. Keep in mind without the fenced back yard a hunting breed is more likely to put the nose to the ground or wind and go hunting on their own.
I am glad to hear you have kids, they'll keep a higher activity dog happy even when their not hunting.
Size... Hmmm I've owned Chesapeake Bay Ret. (not recommmended because of coat) I've seen field dogs around 50 pounds and dogs in the show ring as much as 125 pounds. Both not breed standard. I guess what I am saying is to look at the different traits of the hunting breeds find one that suits your needs and one that you can suit theirs and find a breeder. They might know of someone in their breed that raises the smaller range size of a larger breed, so I wouldn't count out the larger breeds.
As a breeder, of field and show dogs I try and represent the breed as close to standard as I can.
I'm going to say it again...Black and Tan Coonhound....Not as hyper as the forementioned breeds, a large dog and a smooth coat to avoid the shedding issue. Please consider this breed, it might be a perfect match...and yes Poodles were originally water hunters and a can't see a Bassett Hound active enough for this family's needs.