Complex response of a sand‐bed stream to upstream impoundment