Getting away from Altium-specific discussion here, so you might get better discussion on another subforum.
There are lots of resources out there that discuss IPC requirements, and you can even find copies of many of the standards documents floating around on the internet.
As far as accounting for manufacturing tolerances in your footprint design, in general you first have to determine your limiting values--for example, the minimum pad size that will result in an acceptable solder joint, and the maximum pad size that will allow for adequate clearance from adjacent pads/tracks. Let's say that's a minimum of 0.8mm and a maximum of 1.1mm. Then you look at your manufacturing tolerances, which specify the range of actual dimensions you might end up with for a given specified dimension. Let's say the tolerance on the pad size is +0.03/-0.05mm. That means a pad you specify as 1mm may end up being anywhere from 0.95mm to 1.03mm. You can then subtract the positive tolerance from the maximum allowable pad size and the negative tolerance from the minimum pad size to determine what pad size you can specify. In this example, that's 0.8 - (-0.05) = 0.85mm Min and 1.1-(0.3) = 1.07mm Max, so you can draw the pad at anywhere from 0.85 to 1.07mm and still be assured that the pad will be fabricated at an acceptable size. That's an oversimplified example, but provides the basic idea. Geometric Dimensioning and Tolerancing is a whole subject unto itself, and combining multiple tolerances (for example, in SMT parts you'd need to account for tolerances in the fabrication of the board, the component geometry, and in the placement of the part on the board) makes things more complicated.
That said, what are you really trying to achieve? You can go very deep into the engineering behind footprint design, but that's just one piece of designing a PCB. Getting into that after making your first PCB is kind of like going for a PhD in semiconductor physics after blinking an LED with a transistor. You don't need to go that far to get serviceable results, especially for personal/educational/on-off projects. If you're still in the early stages of learning PCB design, it's far better to develop a broad understanding of the whole field first. Get a board designed, built, and tested, then get a second one designed a little better built and tested, then a third a little better still, etc. Get a bit deeper in different areas each time, and make a note of what aspects of your designs worked well and what didn't.