What kind of dog would you recommend for a non-dog lover whose husband and kids (6&8) really want a dog. Think no smelly, little shedding, no drool, easy to train, good with kids, not yippee...

I'd go with a Poodle, Labrador, or Miniature Schnauzer. If you need more options, take a look here:

Best dog breeds for families and Odorless dog breeds

Please remember that in order to have a well-balanced dog, the owners have to be aware of its needs like regular physical and mental exercise, discipline, proper socialization and proper human leadership. These requirements don't depend on the breed, they are true for any dog. You can read more about it here:

This every dog owner should know

Goldens Retrievers are great easy going family dogs.
My Mom was in the same situation a long time ago. We had a Golden Retriever and in the end she was the biggest dog lover of us all.