Obviously there'd be two operating systems on two different drives????
yes but it will only boot from the drive in the SATA 1 port.
To make it boot from the other drive you will need to edit the vista boot loader and more importantly change the drivers in XP to suit the new machine.
However you will still be able to access any data / photos on the drive just not run any programs that are installed on the drive until you do the above.