The future of Cardiff's New Theatre has been secured, after a deal was signed between Cardiff Council and HQ Theatres.