Great Gransden is lovely, but not great schools wise at secondary level.
If your budget is limited, Cambourne is worth considering - you get a lot of house for your money, and a great sense of community with loads going on. My teens spend a lot of time there!
It's worth working out which side of Cambridge you want to be. I don't really know the villages to the East of Cambridge. If you go Southeast, Fulbourn has a lot to offer. Shelford is lovely to the South, but very expensive.
If you go north then there are large villages like Histon and Cottenham, with lots of shops and facilities.
What I like about Bpurn is that, got a small village, there's quite a lot on offer, including a one-class-per-year primary (most small village primaries have two year groups per class), a GP surgery, a shop, a dentist, a butcher-cum-deli and a lovely pub.
I'm sure someone else will come along with more suggestions shortly.