Contentious plans for a social housing estate on Cork’s northside have been approved after officials agreed to an even mix of social and affordable homes.