Davidson said "I'm extremely grateful to have been a member of this outstanding community that has genuinely welcomed me and my family.
"Central Hawke's Bay will always be a special place for us, we've made many amazing friends, connections, and memories. However, the time is right to return home and lead Horowhenua District Council through what is an exciting time of growth for the district."
With high-level applicants from across New Zealand putting themselves forward for the now vacant role, the council still has some final decisions to make in order to confirm a permanent new chief executive for the district.
In the interim, the council has appointed a well-known face around Hawke's Bay, Neil Taylor, as acting chief executive of Central Hawke's Bay District Council.
Taylor is known in the region in his capacity as former chief executive of the Napier City Council, a position he held for 20 years, and as acting chief executive of Hastings and Napier City Council.
Taylor says he will be taking a light touch approach as chief executive at CHB, with high governance confidence in the capability of the leadership team.
The announcement of a permanent chief executive is expected within weeks.