I don't know of any sites like that, but you can do it using ArcGIS Explorer. Use the aerial photo as your basemap, then bring in a topo layer over top of it, then reduce the topo to like 50 or 60 percent transparency. That should give you the effect you're looking for.
