I know about histograms and also know that if we connect the mid-points on the top of bars in a histogram we will get a frequency polygon. This polygon could then be 'smoothed' in a way that it generates a frequency curve like in normal distribution, Poisson distribution, etc. What is smoothing? How is it done? I have heard about the 'filtering techniques' and 'removing noise' but I don't understand the terms. Googling yields things like Kalman filter, moving average filter, low-pass filter, kriging, convolution, etc but they are very abstract concepts for me. Is there any good resource to start learning about these things from scratch?
To start with the title question, the density function is (for a continuous random variable) a function that describes the relative probability of the values taken by the variable (it is not probability! the word relative is important, since the probabilities are all zero); loosely it's proportional to the probability of being within a very small interval containing the point.
So where the density is high, values are relatively more probable, and where it's low, values are relatively less probable.
Areas under the density, between values on the x-axis, do give probabilities of lying in those intervals.
Here's an example of a density function:
The height can be taken as relative probability in that the height at 2 (about 0.27) is saying that a value very close to 2 approximately twice as probable as a value very close to 4 (where the density is about 0.14). [At the risk of sounding repetitive, the density at 2 is not the probability of getting 2, because density is not itself probability. Indeed density can happily exceed one for example.]
You could work out the probability of getting a value between 2.5 and 3.5 by finding the area of the curve between those values (that area turns out to be 0.223 for that density).
See this description relating to an analogy which might give a clearer sense of why it's called 'density'.
When dealing with discrete random variables, such as counts (and this is where the Poisson you mentioned comes in), you're not dealing with density, but an actual probability function (sometimes 'probability mass function'). The height of the probability function is actually the probability of the given value.
You seem to be envisioning specific, named probability distributions as things obtained by manipulating something derived from data (smoothing a histogram).
Generally speaking a probability distribution such as the normal is a model, a hypothetical construct that is an approximation for the behaviour of some variable or variables.
Such simple models are not typically obtained by 'smoothing' a histogram or a polygon, but suitability (or more accurately, unsuitability) might be approximately assessed by considering such displays. Beware, however; using things like histograms - and by extension, frequency polygons - to assess distributions. Using them for this purpose must be approached with caution, as they can be misleading if taken too readily at face value. QQ plots and quantile plots or empirical cumulative distribution functions would often be a better way to spot the suitability of such models, though interpreting QQ plots in particular require a little more effort to learn.
See also this answer.
Smoothing of empirical distributions to produce approximate densities does happen (though kernel density estimation would be a more common way to do it than looking at frequency polygons, along with a few other techniques for producing smooth density estimates), but not, typically to identify a simple functional form. Usually such smoothing is done instead of identifying a specific functional form - one can deal with the smooth density estimate on its own terms, without naming it.
See here for a non-mathematical description of what a kernel density estimate is.
Here's a kernel density estimate, for data that doesn't come from a normal distribution, or a gamma distribution, or a lognormal, Weibull, beta, Burr, etc, etc:
As with a hypothetical density, these empirical density estimates give some assessment of the relative probability (assuming the density is smooth and doesn't vary too quickly)
Your later questions at the end there conflate a whole set of topics which are mostly unrelated to the initial question. You might do better with some books to start, rather than googling, which will lead you through a topic rather than exposing you to large numbers of not-closely related terms.
A possibly relevant post to a number of those topics with a number of links is here