In Dungeon #78 there's an adventure called "Peer Amid the Waters," in which the PCs end up exploring a pyramid interior. It's a little odd in that the pyramid's interior is now flooded with lake water, despite it still being in the middle of a desert.
Johnathan