All roofs of every dwelling structure shall be maintained weathertight and roof drainage shall be handled by suitable collectors and downspouts connected to a public storm sewer. Where a storm sewer or other storm drainage outlet is not available, downspouts may discharge onto splash blocks or into other devices, provided that no excess water flows onto adjoining property or over sidewalks. Connection of any pipe carrying roof water or yard drainage to a sanitary sewer is prohibited.