A scheme to build “100 per cent affordable” houses over land that has seen “immense problems with fly tipping and anti-social behaviour” has been approved.