Council leaders have vowed to open a major leisure and hospitality scheme in Durham City centre after years of delays.