CAVIAR: Conditional diffusion policy for Autonomous Visual Inspection using Aerial Robots