Transactional replication will give you near real time updates, but there will be a few seconds delay, depending on how bad the latency is between the two sites. With Mirroring, you will be able to generate snapshots of the secondary database, but that will require an Enterprise Edition license.