This is governed by the local municipality. Those which require a CofO for rentals will have a basic inspection for safety purposes. That inspection may not include septic or well. Check with the municipality. If you have a concern about the well and/or septic, check with the town about when permits were issued or ask the property owner about the history.