Possibly the fuel mixture is too "rich" or has too much gas in the fuel to air ratio.
This would make it idle rough or fast and the popping noise could be the unburned fuel igniting in the exhaust system on the hotter than normal exhaust manifold.
One check is after the engine has been running for a while check out the exhaust manifold to see if it is glowing red (best observed in the dark of night) this is a good indication of a over rich fuel to air ratio, and is not good for the engine.
This engine would need the fuel to air ratio corrected by a qualified mechanic.
When was the last time you changed your O2 sensors? They are supposed to be changed about 60,000 miles. Could be responsible for rough idle and popping in the exhaust. Otherwise it is likely a vacuum hose that is leaking.
Is it coming from the front? If so then it is a lower ball joint. If you're not too machanicaly inclined, I would recommend taking it to an automotive shop.
The sound you hear in your knees when you walk could be due to the movement of tendons or ligaments over rough areas of bone. This can create a popping or cracking noise known as crepitus. It is usually harmless, but if you experience pain or swelling along with the noise, it's best to consult a healthcare professional.
Runs rough, water coming out of tailpipe if I was a betting man I would bet my last twinki that you have a cracked head or head gasket. water is crossing over into your exaust valves causing the water to come out of your tailpipe and the decreased power in the runs rough is from the compression leak. I am willing to bet that when your engine is running and your radiator is full along with your overflow you have bubbles blowing into your overflow if everything is not full fill it annd check.
when stopped at red light or when in park
sounds like an injector is bad.
My 1997 Honda CRV is making a rattling noise when driving in rough roads
With a bad/burned intake valve the engine will idle rough with a skip and lose power. The cylinder in question will test low in compression. If the valve is damaged bad enough the engine will make a popping noise through the carburetor or throttle body especially during acceleration.
have the Fuel injectors checked out.
They have rough skin they are really scary they have a tail that makes noise.
supercharger seals could be bad
It may be in need of a good tune up.