Rattling pipes can be caused by a number of problems.
1. Ball cock diaphram is old and needs to be replaced.
2. Rubber gaskets inside faucets are loose and vibrating.
3. Pipes are improperly strapped.
4. Calcium and mineral debris is loose behind a valve.
When the ball cock diaphram is old, it looses its elasticity and cannot close and form around the seat inside the valve. When this happens micro fine vibrations begin. Replacing the ballcock costs about 10 dollars and comes with instructions for installation.
Often the rubber gaskets inside old style 2 handle faucets become loosened by age. When the water flows across the open or valve as its closing, it vibrates. The gaskets are about 70 cents. Buy a book on home plumbing repair by Black and Decker for installation instructions.
Since your piping is about 25 years old, I would guess its copper. Copper was often installed with metal hangers and installed in joists too tightly...sometimes not strapped. Since copper expands and contracts (up to 3" in 100 feet) it moves inside the joists and hangers. Many times after the water is shut off, it contracts back to its original size. The noise often sounds like a vibration or clicking.
Finally, once in a while a piece of debris from the city gets stuck behind a shut off valve, as the water flows past it, it vibrates and sends an echo through the piping. This is much more difficult to fix and find.