The actor plans on telling stories about his famous friends - everyone from Al Pacino to James Gandolfini - while also showing off his singing skills