The Welsh singer, whose hits include Total Eclipse of the Heart, passed away "unexpectedly" in hospital, her family said