As a needle has a good bit of taper to it you should be able to use a hard piece of wood behind it to restrict the penetration and make a smaller hole as needed. Simple get a larger needle for bigger holes. If you have or know someone with a set of calipers you might could measure the needle diameter to get an idea how big the hole is going to be. If doing a smaller hole than the shaft of the needle the measure how far up the taper of the point the right size is and try to aim for that depth when "drilling" the hole.