The total amount of rubbish generated in Scottish homes has dropped to its lowest recorded level whilst recycling rates continue to climb.