Sam Northeast admitted promotion to Division One ranks among his proudest moments in cricket – but confessed the achievement comes with a bittersweet edge.