Of course he will still cause chaos, he is the embodiment of chaos itself! Celestia is likely going to give Discord his own personal realm or area to be himself in. The show also has a lot of the concept of balance, Celestia/Luna, sun/moon, Applejack/Rarity (rural/urban, or messiness/neatness), Rainbow Dash/Fluttershy (extrovert/introvert). If life is too ordered, it is boring, and as Discord showed, too much chaos is a bad thing too. Chaos is a neutral force, personally, I didn't see Discord as malicious, just mischievous. I think Discord was telling the truth, in the episode where he was reformed, Fluttershy refused to use the Elements of Harmony to turn him back to stone, if Discord truly didn't care about Fluttershy, he had nothing to lose as the Elements are useless without unity. I think Celestia saw Discord as a potential strong ally in an upcoming story arc. I don't think Discord will try to take over again, however I do think he will still play tricks on the mane six, just for kicks.