The Durham / Newcastle, and even the Northumberland borders nearly all meet somewhere near Byreside (I think).
You can see Newcastle from Byreside too, even though you're in 'Durham', look through the trees, (Hamsterly Forest). Also, the Coast to Coast trail passes right next to the camping side of the site with the toilets and showers on the other side of trail.