My main question is this: What is the LDS view of the Trinity? As a Catholic, I believe that the Trinity is One Being (Father, Son, Holy Spirit) in three persons (consubstantial). I guess my question boils down to this, do they (LDS) believe that the Trinity is One, or three separate beings?
The short answer:
Three separate and distinct beings.
In the Doctrine and Covenants (LDS cannon), it states:
Additionally, in Joseph Smith-History he recounts
David's link also has good information.
Put simply, they don't believe in it, not the way mainstream Christianity does. They believe in all three entities, but that all three entities are distinct, separate beings.
They refer to the three as "The Godhead". There's more here: http://www.lds.org/topics/godhead?lang=eng