Kylie Minogue, Lulu, Deacon Blue and more than 2,000 performers will bring the curtain down on the 2014 Commonwealth Games in Glasgow later.