When is the right time for a middle leader to step up to whole-school responsibility? Lucy Flower offers her insight