"With great eagerness" would be better at the end of the sentence instead of after He. You can say He, with great eagerness, looked forward to the venture - but that would be too long and complicated. It would be much simpler and direct to just say, He eagerly looked forward to the venture. I would choose eagerly to keep it short and simple and easier to understand.