Tesco do a cloudy lemonade with "real lemon" (which begs the question of what's in their other stuff - I know, don't ask)which isn't too sweet.
Diet lemonade generally has aspartane in it, which, IMO, is even more disgusting than the over-sugared variety.

Paws