In case you weren’t aware already, North Herts has prepared a Local Cycling and Walking Infrastructure Plan based on a study by WSP and is now consulting on it:
The consultation is here:
https://www.north-herts.gov.uk/have-your-say-walking-and-cycling-routes
The Plan includes interventions in Royston which may be helpful to people in Bassingbourn-cum-Kneesworth.