If you have a wet salt tank water softener, then yes, there should be standing water in the tank all the time. If you have a dry salt tank water softener, there should only be water in the tank for a few hours before the system regenerates. Constant water in the tank is a sign of a problem with your water softener.