Taking a counter-offer is a huge gamble.

The company now knows you are looking, and willing, to leave. They may just be counter-offering to keep you on until they can hire and train your replacement.

Every situation is different but the general consensus is not to accept a counter-offer unless it comes with a guarantee of employment for X months. And then you need to plan on being let go after X months.