Outside the base on the centre line on the approach but on private land.
Red arrows generally don't come in low, there's strict rules about height and where they can fly low. Ground hugging on approach isn't one of them, especially for the display team.
Since the red arrows take off and at times land in formation or numbers, it makes for a good spectacle.
At scamp ton at either end of the runway is a public road, not far from the perimeter fence. I can only guess some are walking onto the field, under the approach, and some don't like it, but there's no other such restrictions anywhere else in civil aviation.
Raft lyneham, had the approach lights across a field and in a house back garden.