Having rented, driven, and been pulled over on both sides of the border, my experience is that a rental from even a moderately reputable company should come with all the insurance you need to comply.
Additionally, though the OP doesn't own a car (for some people, insurance from their home car can give added protection while renting) your credit card will likely provide any additional coverage you need (check your terms...).