Welcome here on hcm.
Sweat itself doesn't smell. The smell is activated by bacteria on the skin. Try showering with an antibacterial soap before bed and see if that helps.
Your condition of excessive sweating
is called sleep hyperhidrosis
. If you are otherwise healthy, it is a nuisance, but not something to worry about. There are many disesases and conditions that cause night sweats
, but they would have been discovered if you have seen docs.