Councillors have agreed a 7.5-hectare extension to one of North Yorkshire’s largest quarries despite objections from local residents.