A much-loved Wearside museum is celebrating after being recognised with a royal honour.