From buzzing social hubs to peaceful family enclaves — a local's guide to where to live, rent or invest.