Working-age residents in North Lincolnshire facing "terminal illness" will no longer have to pay their council tax bill.