The award-winner teamed, often with lyricist Hal David, on such classics as “The Look of Love” and “(They Long To Be) Close To You”