Do you need a big backyard for a border collie?

plain and simple no. they need a lot of space to roam and run around it.