Celine Dion brought the curtain down on a rain-soaked but spectacular opening ceremony for the Paris Olympics - which also featured a performance from Lady Gaga on the banks of the River Seine.