Will CS2 work with OS X version 10.11? If not, what version do I need to buy, and will that version of InDesign read my CS2 files?
No. You'll need to subscribe to Creative Cloud. CS6 is not going to be supported under 10.11
And yes, CC should open your CS2 files but be prepared for some text reflow if you edit them.
Retrieving data ...