Ireland’s oldest city is to get a €10m facelift to make it more “people-centred” and to create world-class public spaces at its heart.