A Portsmouth attraction has officially been crowned as of the best museums to visit in the UK.