Hi, so I just learned knitting over Christmas break

and I'm making my first scarf and I'm just wondering I guess like what happened if I use a size 3 needle or a size 10? Can someone just explain to me like how the stitching is different? Does a bigger needle use more yarn to finish a scarf?