Governments sometimes analyse waste water for drugs and drug metabolites. You can't pinpoint specific houses' drug use, but you get get trends and general population data.