Plans have been approved for a village housing development despite pleas from residents for the scheme to be rejected.