No one likes strange smells, especially if they are coming from something that we are about to eat or drink. In the case of your drinking water, having odors is never very pleasant, considering how we use that for many different things around the home. It might be a small comfort, but most of the odors that come from your water, aren’t really all that harmful for you. Many of the substances that can end up in your water that are truly harmful don’t have a smell to identify them.
If you are connected to a municipal water system, you have very little control of the quality of the water that you receive, but once it is in your home, you could install filters that will improve the quality.
On the other hand, if you have a well, you have all the control, but not the resources that a municipality does. To find out the quality of your water, you will need to send a sample to a lab for testing.