CWG comes to an end with colourful ceremony