The days when Harold Macmillan could disappear to the grouse moors for the summer are gone – but even prime ministers need a break, says Guardian columnist Martin Kettle