Hammer of Fire

A Two-Round Living City Tournament

Round One: Perchance to Dream

Round Two: Wrath of Talos

From the introduction:

The Wizard’s Guild needs some heroes to go on a very unusual quest. You must discover what cataclysmic danger rushes toward the unprepared city of Ravens Bluff, before it is too late. This is a challenging adventure for a well-rounded team.
...
In Round One, you learned of a terrible threat to the city. Now it is up to you to prevent a cataclysm. The mission may be dangerous, but how can you refuse when the alternative is such devastation? This is a challenging adventure for a well-rounded team.