Hollywood actor Michael Sheen has used £100,000 of his own money to eliminate £1 million in debt for 900 people in South Wales.