A Sopranos star has revealed his struggle with mental health issues nearly 'destroyed' his life and family