Seán Scully insists his marriage and fatherhood have lifted the gloom in his monumental paintings, reports Marc O’Sullivan