It really depends who paid for your subscription. If your council has paid, then the membership stays with the council and cannot be transferred to another council if you leave (the membership is taken up by your successor). If you have paid for the subscription then the subscription remains with you.