Advancing Spiking Neural Networks for Sequential Modeling with Central Pattern Generators