A planned €40m revamp of Spike Island, to create a tourist mecca, will include an events centre with a capacity for 6,000 people.