I am using spartan 3A DSP kit , ... i want to use the usb port on the kit for outputting the video data, ....... if i use a usb IP core , would my PC be able to detect it as a mass storage device or i have to do something else to store the data??
Take a look at the User Guide. It has the pin out and USB controller information you are looking for.
Start on page 17.