It is just for CPU right?
Yes, this SDK 2.0 beta is for CPU only. It focuses on OpenCL 1.0 for CPU.
Brook+ is now available on SourceForge: http://sourceforge.net/projects/brookplus
Will the next release of brook+ allow local arrays? If so, when?
Will Brook+ over after OpenCL come?
With Brook+ on SourceForge, this means that it is now a community-driven project and will not be tied to AMD's v2.0 schedules. It most certainly doesn't mean that Brook+ no longer exists with OpenCL. It is now running in parallel with OpenCL. If the maintainers chose, an OpenCL backend for Brook+ is not out of the question.