Tributes have been paid to a former chief executive of Hartlepool Borough Council.