A popular Edinburgh bar has teased its long-awaited return in a new video - and it shows a stunning transformation of the venue.