A plan to put up over 34,000 solar panels on Herefordshire farmland has been given the go-ahead despite being opposed by locals and the leader of the county council.