Plans for a solar farm next to a "uniquely picturesque" West Yorkshire village with an ancient church have been approved despite dozens of objections.