Plans for up to 100 homes and sports facilities in a village have been approved, six years after they were first proposed.