Art critic Alastair Sooke discovers how museums around the world are changing from grand, intimidating treasuries for objects to something more dynamic and inclusive.