Decommissioned North Sea platform’s new lease on life as ‘one of the UK’s largest public art installations’ – gallery