Obvious, because of its location, is the Red Lion next to Whittlesford Station (perhaps renamed Whittlesford Parkway) some 1.6 miles from the main entrance to Duxford.
I've never stayed there and have only used it as the start venue for a motor rally and that some 25 years ago, but the advertisements speak highly of it.