In regards to beer scene, Manchester, NH would not be your choice. Things are improving but they have a long way to go. Not to mention the schools in Manchester are in big trouble now with overcrowding.
I live in Derry ( about 15 miles south ) and love my town. I'm just not sure it has everything you are looking for. Getting into Boston can take 45 minutes - 3 hours, not much in the way of commuter rail ( although buses are an alternative ). The schools are excellent though. The high school in Derry is Pinkerton Academy ( private school the town contracts with for the high school ). It is one of the reasons we moved to Derry...it sure wasn't because we like to pay outrageous taxes.
I'd say if you are looking in NH, the Seacoast area is your best bet. Or Lovell, ME...right near Ebenzer's pub