Competing for water: Understanding conflict and cooperation in local water governance