We didn't see much of Vision in Avengers: Age of Ultron (we didn't see enough of him, in my opinion), but we're guaranteed to see more of him in the upcoming Captain America: Civil War, although maybe not in the way that we expect. Paul Bettany recently stated that his super powerful android could possibly be a force for evil in upcoming MCU films:

"He must be both omnipotent and yet totally naive at the same time," Bettany said at AsiaPOP Comic Con (via Phillipine Entertainment Portal). "And experiencing the world in real time and his place in it. Is he going to be a force of good or a force of evil? It was really interesting, fun to play with, because he's dangerous, you don't know if he's going to go one way or another. I'm continuing that theme in Captain America 3."

It's interesting that he refers to his character as "omnipotent" and "naive"; it sounds like the character won't be evil himself, but that his immense powers could potentially be used for evil, just as Scarlet Witch was used for evil purposes in Avengers: Age of Ultron. According to the Civil War promo art, Vision will be on Tony Stark's team along with War Machine, Black Widow, and Black Panther, which is not necessarily the "evil" side (depending on your opinion on the security vs liberty conundrum), but his powers could potentially be used for nefarious purposes. And if his statements are to be believed, he may yet oscillate between the two sides, which would be in keeping with the comics.

Bettany was also pressed about his contract with Marvel, and while he confirmed that he will be in further movies after Civil War, he refused to name a specific number of films he's contracted for:

"As an actor, the other part of it is knowing that you have work in a year's time. I've never had that… It's the first time in my life that I've had the security of knowing that I've got a couple of movies to make."

So I suppose we can assume that the all-powerful AI will survive the next film (we probably would have assumed that anyway), and that Vision will have a significant role in the future of the MCU. It's possible that he will help form a new team of Avengers, along with other relative newcomers like Scarlet Witch, Ant-Man, and maybe Spider-Man.