The former Mayor of the West Midlands has said he can't wait to get started in his new role leading a city theatre.