I can't speak to Dreamweaver, but I can confirm that, with a little bit of Java six InDesign and Illustrator CS3 all work fine in Yosemite. I much prefer the more recent CC versions, but based on this Dreamweaver CS4 should work, though installing it might be quite tricky, and obviously there's no chance of support, updates, or bug fixes.
How long Dreamweaver will continue to work is anyone's guess. I'm not running the El Capitan beta so I can't tell you if any of those apps will work in it.