The singer, best known for her song As Tears Go By, and actress died surrounded by family