May the charter be amended to provide that a mayor who is selected by and from the governing board may only vote to break ties?

No. The statute specifically states that such a mayor "has the right to vote on all matters before the council." If a city wishes to limit the voting powers of such a mayor, it would have to request the General Assembly to make the necessary amendment to the city's charter.