It is possible to stay in Grantchester at the Blue Ball Inn (01223 846004) on Broadway which operates a Bed and Breakfast.
There is also plenty of accommodation in and around Cambridge. Two nearby options in Trumpington are: The Lord Byron Inn, and Anstey Hall . Here is a link to Cambridge Tourist Information’s accommodation page.