Rev Ian Paisley has announced he is to resign as leader of the Democratic Unionist Party and First Minister in the northern Executive in May.