Huge Scottish museum with 'beautiful exhibits' named one of the world's best