Council knocks back proposal for huge housing development