Plans for more than 100 social housing units on four inner city sites are set to breathe new life into the heart of Cork city.