The singer of the band best known for the 1985 hit “You Spin Me Round (Like a Record)” passed away from a heart attack