The leader of Cardiff Council said the music venue is expected to be reopened in time for Cardiff Singer of the World in 2027