From Stonington, Maine, to Carmel-by-the-Sea, California, these picturesque locales prove that living large isn’t a requirement for living beautifully