Not quite. We would say "It makes my mouth water".
This also produces the adjective "mouthwatering", eg: mouthwatering smells were coming from the kitchen.
For animals, such as dogs, in the same situation we use the verb 'salivate'.
- For Teachers