There are web cams that connect directly to ethernet that do that but most folk would not want that. Get a regular web cam and on today's PCs the overhead of the web cam is quite small. However what we do with the video will determine the final load. It has little to do with the web cam itself.
Bob