Combine the water, beets, onion, and salt in a large stockpot and bring them to a boil. Cook for 1/2 hour on low heat. Stir in the sugar and lemon juice. Cook 10 minutes more. Refrigerate the mixture to chill, about 30 minutes. Serve the borscht topped with a dollop of sour cream.