A development of 800 new homes at a village has been voted through despite hundreds of locals opposing it.