Sparsity-Aware Hardware-Software Co-design of Spiking Neural Network Accelerators