IT doesnt matter at all where you put it, except for two things:
1) the point at which the tube enters the catch can must be lower than the point where it leaves the radiator (this is virtually impossible to mess up unless you put it on the hood, lol)
and more importantly -- a lot of folks DONT do this,
2) The catch can must have the tube attached to the BOTTOM. Race cars only need the "catch" can to avoid spilling fluids on the track, it's a true "catch" can. Ours is a RESERVOIR. In other words, not only does the motor shove extra coolant in there, but can, at times, suck coolant back out. without this, if the motor starts running hot for whatever reason, you dont have that reservoir to keep you going that much further. Anyone who has changed their own coolant has seen the coolant system suck the reservoir dry as you refill it.
Every time I see someone who bought the aftermarket catch can post pics of their engine compartment with the tube at the top, I cringe. Your motor will run fine like that, but if you need the extra coolant....too bad.