Terminally ill people with less than a year to live will be exempt from paying council tax in Hull, councillors have confirmed.