I noticed that the water from most of the taps seems to be aerated giving it
a really soft feel - great for hand washing. Also some shower heads have a
similar feature.

Do any UK fittings offer this? How is it achieved?