How to wake my Mac remotely so I can use screen sharing?
The aptly called WakeOnLan is a free, simple tool for Mac, both available as application and widget.
What is WakeOnLan?
WakeOnLan discovers all other computers in your LAN, and enables you to wake them up by clicking a button. If your remote computer is a Mac you can put it asleep too.