Wand attachment with rotating head for efficient cleaning