On earth, much light in nature comes from stars like the sun, which have been shown to behave like Lambertian blackbody radiators. Lambertian can be taken to mean that the source is relatively sizeable and therefore it is not a single point of light in the sky. Blackbody radiation was explained by Planck and Einstein, who first realized that the emitted light was not continuous but quantized - in the form of energy packets referred to as photons.
Photons are not emitted uniformly in space and time but according to a distribution described by Poisson: you may see a steady 60 cars per minute passing under a bridge, but you won't see a steady 1 car per second. We say that 1 car per second is the mean number of cars that pass under the bridge, and the observed typical deviation from that mean is the standard deviation.
The standard deviation of light packets emitted by such a source is what we refer to as photon Noise in photography. Their mean is what we refer to as the Signal.
So the ratio of the mean to standard deviation is the Signal to Noise Ratio (SNR), which correlates well with our impression of how noisy an image appears.
It turns out that these concepts generalize well. In other words photons are emitted according to Poisson statistics; after some of them have been randomly scattered or absorbed (say by clouds or glass in a lens) the continuing photons still follow a Poisson distribution; this is also true of the process which turns photons interacting with the photodiode in a pixel into photoelectrons (the photoelectric effect) - also resulting in such a signal. There is no one for one correspondence but the mean and standard deviations are those of Poisson distributions once one accounts for losses (or Quantum Efficiency). And so it goes.
In photography we often say 'photon' noise when photons are directly involved, and 'shot' noise generically. 'Shot' because the pattern of recorded counts by a uniformly illuminated patch of pixels on a sensor is similar to what one gets when shooting a shotgun at a wall.
Jack
PS A bit more here: www.strollswithmydog.com/information-theory-for-photographers/
PPS More in depth explanation by Antisthenes at the old farm.