Anybody know the song at the end of episode8 series6 playing when Gibbs goes for a drink in bar.

If you were talking about episode 7 (Collateral Damage), than the song is "Troubled Land" by Jhon Mellencamp

He did not go to a bar in that episode (season 6 episode 8: "Cloak"). Maybe you're thinking of a different episode?