Adobe has posted a Leopard Support PDF which outlines the compatibility between their line of products and Apple's Mac OS X Leopard. The information is summarized by MacCentral:
Adobe Photoshop CS3, Flash CS3 Professional, Contribute CS3, Dreamweaver CS3, Fireworks CS3, Flash Player 9, GoLive 9, Illustrator CS3, InCopy CS3, InDesign CS3, Bridge CS3, Version Cue CS3, Device Central CS3 and Acrobat Connect (Start Meeting) are all compatible with Leopard.
Products that will require updates for full Leopard compatibility include Adobe Acrobat 8 Professional and the companys professional video applications, including Adobe Premiere Pro CS3, After Effects CS3 Professional, Encore CS3 and Soundbooth CS3.
The updates for "full compatibility" are not expected until December - January.