Plans for an East Yorkshire solar farm with the potential to power thousands of homes have been backed by councillors.