Overall drawing tablets are very quiet devices. Many are silent. This document will explain the sources of potential noise
Pen tablets - drawing tablets without a screen - are completely silent. Nothing in them makes noise.
Pen displays - drawing tablets with a screen - are silent or not depending on the model. For example, many of them have no fans - so they are also silent. Occasionally some of them do have fans - and those will produce an audible fan noise. The amount depends on the specific model.
When you drag the pen on the surface of a drawing tablet, there is a little bit of friction. Drawing tablets vary wildly with how rough their texture is.
Depending on the pen nib material and the surface material and texture you might hear the pen move on the surface.
For pen tablets - It can sound like like a pencil scratching on paper. Also it can be very quiet. The nib material makes often makes a big different. Felt nibs can cause more noise than plastic nibs.
For pen displays - these don't produce much/any sound when the pen moves on them because the surface of a pen display is only slightly textured.