If your vehicle is damaged, your car insurance will cover it. In most cases, you don't need to take out any special insurance, such as homeowners or renters insurance.
Please note: if your spot is a box (enclosed garage), you'll need to take out renter's liability insurance (assurance des risques locatifs). Feel free to contact your insurer to find out what this involves.