The drug-addled pasts of musicians such as Sir Elton John, Courtney Love and Whitney Houston, are set be revealed in a new celebrity tell-all book.