A historic city convent which has undergone a €10m conservation and regeneration project is set to open as an iconic heritage and visitor centre.