There will be a new leader at Dudley Council after it appointed a new interim chief executive.