The district is set to introduce a non-means-tested council tax exemption for households affected by terminal illness, starting next financial year.