Acclaimed composer turned out a string of hits like 'Walk on By' and 'I Say a Little Prayer' with longtime lyricist partner Hal David, a fellow Jewish New Yorker