A Dorset museum has been ranked among the top 10 attractions for visitor experience in the UK.