Steven does not leave the museum in Pokémon SoulSilver (or any Pokémon game). He remains the museum's curator throughout.
You might be confusing him with:
Please provide more context if you recall a specific scene.