For scrypt-based coins (like Litecoin), you'll need some fast AMD GPUs (don't bother with Nvidia unless you already have some - they're pretty bad for mining).

For SHA256-based coins (like Bitcoin), it's all ASICs.