After years of anticipation, a top UK museum is set to make its grand return in 2026, at a new location costing £437 million.