The Great Northern Hotel set to re-open