An application for new homes, sports facilities and a car park in a village has been approved, six years after first being proposed.