It had been a long time coming. Nicola Sturgeon's announcement last week that she would be standing down as an MSP at next year's Holyrood elections followed months of speculation.