You need to clarify your question, are you just adding a second drive for storage or replacing your OS drive?
If your system is already running one sata mode in the bios, the newly added drive will use the same mode unless you have a second sata controller on the motherboard that allows its own settings.
AHCI has some advantages, particularly for SSDs, but either mode should work on a modern SATA drive.