Explain the phenomenon of resonance in electrical circuits, emphasizing its importance in frequency-selective filtering and signal processing applications. How does resonance occur, and what are its implications for circuit design?