After eight years of renovation and anticipation, the museum reopens this weekend with a two-day public celebration; ahead of the long-awaited debut, Observer got an exclusive preview.