New ‘chief storyteller’ appointed for reopening Paisley Museum