One of the most important jobs in California's water world comes open next month. It comes with high pay, prestige and plenty of thorny challenges.