About SATA drives click here
SATA vs IDE click here
The motherboard is not affected by HDD size, but you may need drivers if you have not used SATA drives before. Check the motherboard will accept SATA drives before you buy, you should be able to see the sockets on the motherboard. Remember you will also need SATA data cables for your new drive, again if you have not used SATA drives before. You may also need to adjust the BIOS for compatibility.
The larger the drive the more you can store on it. The larger the buffer and the faster it rotates the quicker data will be transfered.