Yes, India passport holders need a valid visa to visit the Myanmar for tourism purposes. You must be outside Myanmar when you apply for the tourist visa. Also, you cannot work in Myanmar with the tourist visa.
Indian Citizens can apply for an e-visa prior to their visit, which is a convenient and efficient way to obtain the necessary travel authorisation without visiting an embassy or consulate.