Plans to demolish a vehicle repair workshop near Newport and build a detached home have been withdrawn after concerns were raised about flooding on the site.