Hi. We r city people coming in for a relaxing break. Renting car from providence. Friday arrival and returning Sunday. Wanted a quiet place near or by water with charm. We don't like driving but doing it to get the best of. Recommendations for area to stay and lodging? Assuming we should stay away from hotels? We like to walk, bike and dine. Thanks!