I hear this game can be modded, where do I find mods?
You can find threads about all released projects here
The wiki has information on their use, as well as pages for each project here
Content packs are what you want if you are looking for new textures, music, sprites and sounds.
Modifications do what the name implies, they modify the game files. Currently this requires overwriting the base game but in the future it will be easier.