Mike Hodge, who has been the assistant city manager of Pearland since 2005, will officially start June 23