Is there an adapter available that will permit the connection of
the 24-inch LED Cinema display to a Mac Pro with a DVI connection
at the end of its cable?
Yes "all" you need is an adapter. The problem is DVI and DisplayPort are different signal types. This means that the adapter would have to include special signal converting circuitry/processor making it a rather expensive ~$100+ adapter.