Emergent productivity regimes of river networks