Don't under estimate the benefits of a small town versus big city. Small towns have one thing big cities do not have...convenience.
I have a house in Monterey (28,000 pop) and Oakland (300,000). In Monterey I drive 5 minutes to Costco, 5 minutes to the auto shop, 5 minutes to the hospital, 5 minutes to the shopping center, 5 minutes to the movie, 5 minutes to the airport, and so on. Basically everything is within five minutes in Monterey. Oh, and I can walk to downtown in 15 minutes.
Not so much in Oakland. Costco is 20 minutes away, the auto shop is 30 minutes, the hospital is 15 to 30 minutes depending on which hospital, the shopping center is 30 minutes and so is the movie. And the airport is an hour away or 30 minutes depending on the airport. And the traffic jams are overwhelming so those minutes could swell at any time due to a traffic jam.
I also grew up in a small town. It's 40,000 pop now, but it was 23,000 when I was a kid. In 2009 my home town university won the Division II NCAA National Basketball Championship. This year not so good, but they did make the Sweet Sixteen and were beaten in that by the team that eventually became the Champions. My point, small towns don't mean small minds with nothing to do.
Were I you (and I'm not) I'd take the dream job and the small town. It's rare that you will find a dream job; so grab it while you can.