Troubled Cold Feet star James Nesbitt has publicly apologised for letting his family down after tabloid revelations about drug use and affairs with other women.