How to load the required modules only on Drupal site?
No, there's no such way. Or may be answer is: Yes, it's done automatically. Keep in mind that Drupal loads only the .module file always, and other files (includes, classes, etc) are only loaded when needed. Is true that that 'when needed' may be always for some of the files, but not all.