Airport is right at the city border. It is easily reachable by car, public transport or taxi. More information is available at airport website.
Google Transit is available in Cambridge. So you can find your way in Google Maps. Moreover, you can download any of the offline public transit apps available for Cambridge.
Cambridge has lots of great hotels and hostels. More information will be available later.