Hollywood legend Al Pacino was left 'horrified' by a nickname he was given on the set of a film in the 1990s - and it prompted him to make a drastic lifestyle change