Stargate Atlantis S04 E04 Doppelganger

"A new gate will open. A lost city will rise again."

During an off-world mission Colonel Sheppard unknowingly becomes host to an alien entity, which infects others in Atlantis and afflicts them with terrifying nightmares.