Water pistol with muzzle flash effect