In theory the hard drive should be recognised, the only limitation that you would have is that you can only use the sata controller as IDE, you wont be able to have features like raid, ahci. In the bios, there will be an option ATA/IDE Mode which can be set as Native or Legacy, so if it does not work on Native, it must work on Legacy. Unfortunately, i have never used an ide to sata adapter so i can confirm that i would work.
Now regarding the USB Legacy support, there are several intel boards that donot have PS2 ports now, and it works fine on the BIOS.
You will need to make sure to have these settings enabled in the BIOS:
Advanced >> USB Configuration
USB Ports : Enabled
USB Legacy: Enabled
By defaults these are already enabled. Make sure to have latest bios as sometimes there are fixes in the new bios.
All the best,