From cobblestone streets and wineries to Adirondack views, these small towns are perfect for a weekend getaway.