Yes you can, I do it all the time. They will try to sell you some special insurance claiming the border people might ask you for it. I have rented a car and driven to canada probably 25 times, never got the "special insurance" , never had a problem. Make sure you bring your own insurance card with though as proof you actually have auto insurance.
EDIT: Except ENTERPRISE....They have all kinds of crazy rules.