Plans for a touring caravan site in Leyburn have been approved by North Yorkshire Council.