Kilkenny is to get a €5.6m makeover to help boost visitor numbers to the popular city, it has been announced.