SATA HDs don't look any different from normal ATA HDs; however the cable and power connectors are different.
See this article:
http://www.tomshardware.com/storage/...al_ata-01.html
As far as I know, most of the SATA HDs allow you to use a standard 4 pin Molex connector from the PSU as well as the new power connector.
As your mobo has two SATA controllers, you could, if you wish, connect ordinary ATA HDs to it by using a convertor
http://www.directron.com/ide2sata.html
However, I don't know good these convertor cards are.
HTH