Plans to build a solar farm on a 77-hectare green belt site in Yorkshire have been refused by local councillors.