This Hartford suburb boasts wallet-friendly housing prices, the nation's smallest waterfall, historic homes, and funky shops and restaurants.