New CEO announced as museum moves on from ‘mismanagement’ allegations