Councillors in Glasgow have approved Scottish Opera’s 'ambitious' plans for a new canalside headquarters in the city.