Tucson police chief offers resignation after in-custody death