“There was a tremendous amount of friction between the two of them. There were stories about how they used to get drunk and abuse each other”: The doomed singer who helped invent folk-rock and sang with Led Zeppelin – but couldn’t escape her demons