Will a new SATA II drive be compatible with an older motherboard?

SATA II is backwards compatible with SATA however your speeds will be limited by the slowest component. I would personally use the drive for its capacity and then if you ever get a new motherboard you can utilize the full potential of your drive.