AI Weiwei will take over the Manchester venue with a exhibition being billed as monumental in scale and ambition