The last surviving member of the New York Dolls is also battling a brain tumor and requires around-the-clock care — the Sweet Relief Musicians Fund is raising money for his expenses