Ahead of a new Hayward Gallery exhibition about Louise Bourgeois, Tracey Emin remembers what it was like to be her friend and collaborator