Plans to transform Cathedral Gardens in Belfast into a new civic space and build on other investments in the area have been approved.