As a parent of young children myself I applaud the effort to escape any chance you get!
We've done Opechee and it was surprisingly pleasant. Nice being able to walk back to the room after adult beverages.
One of our favorites was
http://www.thecentennialhotel.com/ in Concord NH. Great rates, fun to go to the restaurants down town, good location, and really nice room.
Church landing is always spectacular if you can get away on a weeknight. Prices get too steep for us locals on the weekends.