The first major retrospective exhibition on the brilliant but troubled British musician opens on 26th November at the Design Museum in London.