Probing the response of quantum plasmonic systems: from the macroscopic to the microscopic