The museum known for its stunning Arab Hall has been refreshed with new spaces (and, yes, a cafe) in a way that breathes in new life