No system-level software needed, but the Wii has no built-in drum function. You need a game that includes drum gameplay.
You cannot use a real electronic drum kit (MIDI/USB) directly. No Wii game supports standard MIDI input. Adapters (e.g., MIDI Pro-Adapter for Rock Band 3) exist but are rare/expensive.