A slower rate of decline in output in Scotland's private sector has offered a hint of optimism for the year ahead.