Sediment dynamics and transport regimes in a narrow microtidal estuary