A historic city building that has undergone a significant renovation is set to reopen next month.