Ireland's greatest artists go on display in Waterford's first purpose-built gallery