The top officer for a new mayoral authority which will oversee tens of millions of pounds of investment in Hampshire has been appointed.