Police chief offered to resign before shooting himself