What you are looking for is the Spread curve, which is available in the Attenuation Editor and varies over distance. It can make a sound "big" when the listener is close and "small" (or "point source") when it is far.
See related articles below for more information.