Dust emission in star-forming dwarf galaxies: General properties and the nature of the sub-mm excess