Gloomy gable ends and scruffy shopfronts are among 24 sites in Waterford’s city centre scheduled for a spectacular makeover in the next few days.