New life has been breathed into one of the most historic parts of Cork City thanks to a €500,000 investment in the public realm and a cultural venue.