Roy Foster welcomes Waterford’s Museum Quarter, which celebrates the city’s heritage in spectacular style