The bridge towers above the village of North Queensferry